List box or combo box not sorted due to not selecting sort method.
Cause:
The 'Row Source' property box is not set to the desired sort method in the Forms Design view.
Solution:
In the Form Design view, use the 'Build' of the 'Row Source' box of the property sheet to set the sort method in Query Design.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click on the desired list box or combo box. (Handles appear around the control.)
7) Click the 'Data' tab in the property sheet.
8) Click on the 'Row Source' box. (A build button appears.)
9) Click 'Build'. (The Query Builder grid appears.)
10) Click in the 'Sort' cell in the design grid for the desired field. (A down arrow appears.)
11) Click down arrow. (A drop-down list appears.)
12) Do one of the following to sort:
a) Select 'Ascending' from the drop-down list to sort in ascending order.
b) Select 'Descending' from the drop-down list to sort in descending order.
13) Repeat steps 10) through 12) for each additional field.
14) Click on the 'X' in the upper right corner of the 'Query Builder' to close the window. (The form appears.)
15) Select the 'File' menu and select 'Save' to save changes to the form.
